UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'd/6km0cvbywO1hpzmz8f5qh7OTDuFi99odoIwjRGmW4='
WHERE
key_id = 'f1903d967e85a327bc501505d3dcaed8c6d455fbe0cbd319428cc99929a6cf2e'
AND (
token = 'd/6km0cvbywO1hpzmz8f5qh7OTDuFi99odoIwjRGmW4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)