UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'lhCmrn77jX/DjM6kj28dkr/8r7YC3Wx6gbauH9OVWHY=' 
WHERE 
  key_id = '2415d470fdf13279631dd84ef68c15c165f39de7066af2e0343e43ded1aa9c94' 
  AND (
    token = 'lhCmrn77jX/DjM6kj28dkr/8r7YC3Wx6gbauH9OVWHY=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00020