UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ehl7EsrI06cnV4Z44c5rQoeCn+pRvV/ZiBm2pH4mxSg='
WHERE
key_id = '565d49f255e63dfa58f6074787edd7ec67b2244a367e6d7421b7397f0d9c96c5'
AND (
token = 'ehl7EsrI06cnV4Z44c5rQoeCn+pRvV/ZiBm2pH4mxSg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)