UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'jGP93/A01j+sQoq6zpb9G1y59xzr7jvT9irRgHUvKCQ='
WHERE
key_id = '7c8776b60af22743c6fc4f2b68f11ae44936d58be8c048e1f0a53aa28d50459a'
AND (
token = 'jGP93/A01j+sQoq6zpb9G1y59xzr7jvT9irRgHUvKCQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)