UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'rcq5diyIhqEmkgDDnrCIWSJOnD6kScqogp7ZebIBRxI='
WHERE
key_id = 'c0feeab7950e84111e4495c200396337c7a086c16932f1e94742c4fb2d541c64'
AND (
token = 'rcq5diyIhqEmkgDDnrCIWSJOnD6kScqogp7ZebIBRxI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)