UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'yTATVVlJrsf6XPKn1PX6UtoAEIqQW2NHCbwpCdSZjx8='
WHERE
key_id = '2aefd97b0e7ea876a8e473b63d2070616ecc26825907723d5be9118e97c75abd'
AND (
token = 'yTATVVlJrsf6XPKn1PX6UtoAEIqQW2NHCbwpCdSZjx8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)