UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'z42jEuHHSsV9d5kXJMfEQNBPSwO9iXnlalRiAEjHmPE='
WHERE
key_id = '1b8ad35264bdfa2c27c25847edbb16a80adbb4a13dc09b2ce5426b499deff7ea'
AND (
token = 'z42jEuHHSsV9d5kXJMfEQNBPSwO9iXnlalRiAEjHmPE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)