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