UPDATE 
  cscart_aprillock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '1No6EqDnn5mCG34/ODk3vxBGUNu+2ohqE5ivebEbtgg=' 
WHERE 
  key_id = '7b97a947846d8641f3ab8ae9f3a9d8d8296b96ab3fd26e6d8f528a07941b4df5' 
  AND (
    token = '1No6EqDnn5mCG34/ODk3vxBGUNu+2ohqE5ivebEbtgg=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00027