UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'NgoYI5kF39zADWn1MQ7UkNc5YUKAWGKzmjH3tMf84b4='
WHERE
key_id = 'ca9462220fa344c2709a1e739c6ec6ef94ac7ac4687788c1156c95b8bd630cea'
AND (
token = 'NgoYI5kF39zADWn1MQ7UkNc5YUKAWGKzmjH3tMf84b4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)