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