UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'RI6ZC8/yrqo454zh4cOIpG59F9cvNRMlTJmn2nsUb34='
WHERE
key_id = 'f0126fb7cdd8a54f1dc38e1ff9663873ff533c061250366ad8a103101a125bbd'
AND (
token = 'RI6ZC8/yrqo454zh4cOIpG59F9cvNRMlTJmn2nsUb34='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)