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