UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'EZ45YvykiJI2+AlLKs+0LsTLrXzNg9BYVOcvAqgVRa0='
WHERE
key_id = 'effa9ef6cbf82ec9093f1f677831ec2fba4bfefb3fa6203cc39ece0d6af8fef9'
AND (
token = 'EZ45YvykiJI2+AlLKs+0LsTLrXzNg9BYVOcvAqgVRa0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)