UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9ah8F+LnJ6hC1cfHkYBOer/9JRRf7Cc5r3h30OMyzEg='
WHERE
key_id = 'b233e81586991cc7142fe9667ac18e868aa3c5f682379e239f41905db75ae07e'
AND (
token = '9ah8F+LnJ6hC1cfHkYBOer/9JRRf7Cc5r3h30OMyzEg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)