UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6COEeD+xFPma4LStBjXUGsPd34RpqfPQZHW1eA4a+pY='
WHERE
key_id = '97987bcfb4045886ecb25e54036cf3fccbf93ba26f53e21062e114bd059dff18'
AND (
token = '6COEeD+xFPma4LStBjXUGsPd34RpqfPQZHW1eA4a+pY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)