UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8b2NZHolS7mdRC4pzZwrp3MivZMQxy7H1tPbTwTLDYI='
WHERE
key_id = 'fd13d3b8a211ec03c6e6c36597c581e3662e1614fc9954dada85138e20560f14'
AND (
token = '8b2NZHolS7mdRC4pzZwrp3MivZMQxy7H1tPbTwTLDYI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)