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