UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'n0kTxdRO247+eBwlBK1EBfezIUxCwl0E3BZ+I+/KWpU='
WHERE
key_id = '6e903c5c451ad8a31590e69e91a1f9b76829e1019e91606f8cdf73af4c303ed3'
AND (
token = 'n0kTxdRO247+eBwlBK1EBfezIUxCwl0E3BZ+I+/KWpU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)