UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6QXP6zPWBdw5Y5jUoKCR2XbcN9mJVn8atC9Ulx6TCSo='
WHERE
key_id = '710ea8ba5d2c48056e3804e29be29b7d6aeb67b2a6db43641be3ddddc3c10997'
AND (
token = '6QXP6zPWBdw5Y5jUoKCR2XbcN9mJVn8atC9Ulx6TCSo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)