UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9Qgn8NvZ9VzTglmhFIwXeFYioAmIyko3lIsAZc95WK8='
WHERE
key_id = 'fa2c84e32a0a32556833a9cdef19f1f0bc8c40ab7b1fdf3b85fae63bfc17e125'
AND (
token = '9Qgn8NvZ9VzTglmhFIwXeFYioAmIyko3lIsAZc95WK8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)