UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1T0zF9bnJDWOTUwdE2HZi8rKPXFfJYY/GUsX4qC0xNc='
WHERE
key_id = 'e43458d6a5a219554526ea9df43ff75d69b678ced7b39196f9897bd02915993c'
AND (
token = '1T0zF9bnJDWOTUwdE2HZi8rKPXFfJYY/GUsX4qC0xNc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)