UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'OWrcQ7r8Y/6oCxw6DDfZMC1dMijJKqEhazoNO8GkjTQ=' 
WHERE 
  key_id = '3f5c3acfb1e77bd8a1867f8e9926aee0fbe4dff5babed113dab1ccf84f8ca08c' 
  AND (
    token = 'OWrcQ7r8Y/6oCxw6DDfZMC1dMijJKqEhazoNO8GkjTQ=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00026