UPDATE 
  cscart_aprillock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '+fXjZKANaCBRVOmWK0NrFUHTkTYM0XJ2bt7FKU+GIu4=' 
WHERE 
  key_id = '0bf327ba1c5c49a95964ce3026950831ead80e78064492da912f4b57cd58ea44' 
  AND (
    token = '+fXjZKANaCBRVOmWK0NrFUHTkTYM0XJ2bt7FKU+GIu4=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00031