UPDATE 
  cscart_aprillock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'WZWOywyAy3gSup0zjozxdSvhBy66ifeB1nD4hYo/jVs=' 
WHERE 
  key_id = 'd6b57cbf0571762436a2ca7c4c8b403c0c597c1417e3b52a063560b06eb66e1a' 
  AND (
    token = 'WZWOywyAy3gSup0zjozxdSvhBy66ifeB1nD4hYo/jVs=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00035