UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '/p/Y01a4O8L2ycHIlQW98X+8gw6NbY8aiEHeBcXvBBI=' 
WHERE 
  key_id = '3842bbf728a9863c383b1ca09d8a5c2ced941a1a56e9f00954326d5819aa3caa' 
  AND (
    token = '/p/Y01a4O8L2ycHIlQW98X+8gw6NbY8aiEHeBcXvBBI=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00034