UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0dpgL92/0omS3xjUzP0WvzhpZ2alGsuTRtOmFlMSR0A='
WHERE
key_id = 'c7513f707fe3bd273c33a2457b456fd2f9aa8c1553250ae2460d1b02efb44ee0'
AND (
token = '0dpgL92/0omS3xjUzP0WvzhpZ2alGsuTRtOmFlMSR0A='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)