UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'x6NZnmibFr3cjoY5en0nIMOpzLqshzODkV5jmxlgXn0='
WHERE
key_id = 'dfdea073f376bbbce5fc8c44f0f5589dd5311f171e0a0fe98fa35bc5d954bc0a'
AND (
token = 'x6NZnmibFr3cjoY5en0nIMOpzLqshzODkV5jmxlgXn0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)