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